Can this be done using excel macos?
I am new here and have been refered to this site by someone who thinks its the best site for programmers. I also think it is!!

I am new to Vb and excel Macros.
I want to do the following things with a 13 column and 1000 rows spreadsheet.

1. Determine the Unique items on Column A to J
2. Move the Unique items to a new Sheet
3. Transpose the data on the newsheet from Columns to rows
4. Space the Unique items(the rows would be determined by the data to be fixed beneath which varies)
5. Sort the Raw Data based on unique items from Column B,C,D,E,F,G,H,I and J
6. and populate the New sheet created earlier by using the unique items and data just after the column with the Unique item
7. Create a subtotal for each populated data
here is a format below

  a     b     c     d     e       f     g........l   m

1 Mike mazer Male  White  London SE    Barman    36 4.52


I would appreciate any response.
Thanks 



Can this be done using excel macos?
===

I am new here and have been refered to this site by someone who thinks its the best site for programmers. I also think it is!!

I am new to Vb and excel Macros.
I want to do the following things with a 13 column and 1000 rows spreadsheet.

1. Determine the Unique items on Column A to J
2. Move the Unique items to a new Sheet
3. Transpose the data on the newsheet from Columns to rows
4. Space the Unique items(the rows would be determined by the data to be fixed beneath which varies)
5. Sort the Raw Data based on unique items from Column B,C,D,E,F,G,H,I and J
6. and populate the New sheet created earlier by using the unique items and data just after the column with the Unique item
7. Create a subtotal for each populated data
here is a format below

  a     b     c     d     e       f     g........l   m

1 Mike mazer Male  White  London SE    Barman    36 4.52


I would appreciate any response.
Thanks 


