Forum Discussion
Splitting a column with 2 values each below the other into 2 columns i.e account number and date
How do I do this, I have 4000 lines with account number on fist row and date on the following row but I would like these two things to be next to each other. The complicating factor is that the date...
N3il-585 Assuming that this is a one time exercise, I'd suggest you insert a column to the right of the one where you have account number and date below one another and enter the following:
=OFFSET(A1,1,0)
Where A1 would be the cell where you have the account number. Copy it all the way down. Then copy/paste-values that new column on top of itself. Filter on dates in the first column and delete these rows. Clear the filter and you are left with the Account numbers in one column and dates in the next.
Practise on a copy of your live file, in case it goes wrong!