I have an excel spreadsheet with data in column A. every entry is three rows long. there are about 1000 entries in column a that need to be separated into columns B, C and D. So as an example, Entry 1 would be in A1, A2 and A3. lets say it is Name in A1, Address in A2 and Phone number in A3. I want the output to be B1 = Name, C1 = Address and D1 = phone number, then A4,5,6 would be in B2,C2,D2... and so on.
I'd like this done WITHOUT VBA. just want a formula.
I have attached the actual xls for your reference.