how to divide a set of data into multiple columns data set

[northcell]

just like the picture I have attached. great thanks

from the top set of data into bottom set of data

excel2.JPG

I made another image to express what I want to get. it's just divide column of data into 3 parts and make them into 3 columns under each categories. great thanks if you can help me out.

excel2-2.jpg

[Kaper]

A9 and copy right:

Please Login or Register  to view this content.

A10 and copy down and right:

Please Login or Register  to view this content.

[northcell]

Please Login or Register  to view this content.

in this command, why there is ROW(A1), I thought A1 is a string and it has no connection with data. so why ROW(A1)?

thanks

[Kaper]

1) above question - it is just a way to generate number 1, and when you copy down 2, etc.
so it could be as well

Please Login or Register  to view this content.

or A10 and copy right:

Please Login or Register  to view this content.

A11 and copy right:

Please Login or Register  to view this content.

2) Please ask merit question only on a forum - not in PM.

3) As for attachments
To attach an Excel file you have to do the following: Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.

If you (strongly recommended) plan to add one:

Please attach a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough)

Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

Make sure that your desired solution(s) is/are also shown (mock up the results manually).

Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!