Neaten up Data using Macro

[Howardc1001]

I have data that is converted from PDF to Excel and then Imported

I am looking for code to neaten up the data so that the text in Col A lines up with the numbers in Col C and E


I have shown what the result should look like on sheet "Final Result"


When running the macro the data must be neatened up on sheet "Imported Data"


It would be appreciated if someone could provide me with code to do this

[Eastw00d]

Hi, here a solution without VBA, only assuming that columns C and E have equal number of rows as column A.

Please Login or Register  to view this content.

Cheers
Erwin

[Howardc1001]

Many thanks for the help Erwin

please explain the significance of this part of the formula

Please Login or Register  to view this content.

[Eastw00d]

Hi Howard,
You should see some youtube films about this aggregate function, they are mostly very instructive.

But this part

Please Login or Register  to view this content.

is the exception of the range that is selected in the part before the "/" : gather all the rows in the selection that are not blank,
the part

Please Login or Register  to view this content.

is putting the gathered selection in the separate rows.

As the aggregate function is very versatile, I really recommend you to watch youtube.

And thank you for the nice remark and the rep.points

Cheers
Erwin

[Howardc1001]

Thanks for your Input


I will certainly listen to the videos