Data Tabulation

[Romulo Avila]

Good evening,

I have a spreadsheet with the data as attached "Range A1: F7", I need a macro so I can tabulate this
data so that it conforms to "Range A10: C23".
The attachment is just an example, my spreadsheet has more than 1000 rows.


Thank you for your help.

[werafa]

step 1, create a list of unique names
(you should find example code by searching for 'remove duplicate data')

step 2, read range 2 into an array, and cycle through this with a for next loop
if first name and lastname match, then find first blank column and write value in range 1

[Romulo Avila]

Good Morning,
Thanks for the help, but I do not have much knowledge of VBA for the creation of this for next, anyway I'll try.