Macro to edit formatting

[kikijean]

Hello!

I have a system that provides a report in a format that is difficult to use. I need to clean it up but I use this report very often, with different data, so would like to build a macro to quickly reformat. I'm not sure how...
To note, the report does not actually export into Excel/CSV, I manually have to copy the data from the screen and paste it into Excel, so I could have a saved Excel template with the macro for the reformatting.

Attached is a sample report, the first tab is the raw report, the second tab is how I want it reformatted. The basic steps are:
1. Keep Row 1 as the Column Headers, but delete all duplicate rows with these headers (as shown in rows 5, 10, 13, 17, 20, 23, 33 in the sample).
2. Delete blank rows between the rows with data (as shown in rows 4, 9, 12, 16, 19, 22 and 32)
3. Copy the data in columns A and B to the subsequent blank rows (ie cell A3 should show "1", and cell B3 should show "Nuits St Georges Faiveley 2002".

The data in these reports will vary, so information will appear in different rows.

Thanks for the help!

[Rick Rothstein]

See if this macro does what you want...

Please Login or Register  to view this content.

[kikijean]

This is perfect! Thank you!