Hello,
I'm in desperate need of help
with an excel spreadsheet. I have a spreadsheet with 20k records. I have data in columns A through N. Every column has a simple entry except for column F which has multiple entries separated by a £ sign. I would like to split up that column into multiple rows (i.e. the info in columns A through N [except for column F] should be copied down with a single entry on column F). After the new rows are created the original column should only have one entry.
Your help will be greatly appreciated
Cheers,
Jack
I'm in desperate need of help
with an excel spreadsheet. I have a spreadsheet with 20k records. I have data in columns A through N. Every column has a simple entry except for column F which has multiple entries separated by a £ sign. I would like to split up that column into multiple rows (i.e. the info in columns A through N [except for column F] should be copied down with a single entry on column F). After the new rows are created the original column should only have one entry.Your help will be greatly appreciated
Cheers,
Jack