For Online Computer Support, Ask a Computer Technician
Hi and welcome to JustAnswer, I’m Louie. Sorry you had to wait awhile but I’ll do my best to help.Initially, just two (2) rows? ...re-arrange so that these would be two (2) columns?
Please post back with the Excel file. Click HERE.
Yes, unfortunatley, could not be automated converted "that" fast as some entries are in a different format.
Please see row 182, 199, 211, 228, 286, 287, 290 and 291
The whole file , click HERE.
On the cell opposite the date, I made it a formula equal to the value of the cell below the date hence B19 = A20
Then I did a "Hide" of the 2 rows below the date hence the file shows row 19 but the next row is22 where 20 and 21 are hidden.
Highlight the entire rows 20 and 21 (or whichever), do a right click, click on Hide.
Manually, only with rows next to each other can be hidden at the same time. BUT the function can be repeated with a Ctrl + Y for the next rows hence: