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 Hey you can try this assuming column 1 have cells blank where the date is in column 2
suppose your data is starting from first row then go to C1 and type this formula
=B2
and drag it till the end
then you apply filter to all data and go to A1 and filter data for blank
then delete all those rows and your data will be ready