Convert datagrid data to raw data

Closed
jppuam Posts 4 Registration date Tuesday March 4, 2014 Status Member Last seen March 4, 2014 - Mar 4, 2014 at 11:26 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 6, 2014 at 10:25 AM
Hello,
i've a excel grid with data in rows and coluns with values in each pair (row/column).

i need to transform each combination in raw data to process to a database with for ex:

row 1 col 1 value (33)
row 1 col 2 value (5)
row 1 col 3 value (56)
....
row 2 col 1 value (32)
row 2 col 2 value (23)
row 2 col 3 valule (12)

col1 col2 col3 col4 col5 col6 col7
row1 33 5 56 66 3 1 56
row2 32 23 12 33 58 98 43
row3 3 7 9 7
row4
row5
row6
row7


can you please help with this,

thanks,
Joao

4 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Mar 4, 2014 at 11:42 AM
Hi Jppuam,

Not sure if I understand you correctly, but it seems to me like you want top transpose your data.

Copy a column > right-click destination cell > paste special > check transpose option.

Best regards,
Trowa
jppuam Posts 4 Registration date Tuesday March 4, 2014 Status Member Last seen March 4, 2014
Mar 4, 2014 at 11:46 AM
Hi thanks for the help,

The problem is that `ve 900 rows with data, and doing that manually is impossible.

What I want is to put row 1 with all the columns (900), than row 2 with the data of column 2 (900 lines), I don't know if was clear.

Thanks,
Joao
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Mar 4, 2014 at 11:51 AM
You don't have to select each row individually, just select them all.

Example with 2 rows and 10 columns:
1	2	3	4	5	6	7	8	9	10
11 12 13 14 15 16 17 18 19 20

would result in:
1	11
2 12
3 13
4 14
5 15
6 16
7 17
8 18
9 19
10 20

Is that not what you want?
0
jppuam Posts 4 Registration date Tuesday March 4, 2014 Status Member Last seen March 4, 2014
Mar 4, 2014 at 11:54 AM
i dont think so. can i send an excel file ?
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Mar 4, 2014 at 12:03 PM
Sure, go to a filesharing site like www.speedyshare.com or ge.tt, upload your file and post back the download link.


Signing out,
Trowa
0
jppuam Posts 4 Registration date Tuesday March 4, 2014 Status Member Last seen March 4, 2014
Mar 4, 2014 at 12:10 PM
i've sent you the file to the rely to email,

can you please check it.

thanks,
Joao
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Mar 6, 2014 at 10:25 AM
I will look at your file, when you post back the download link in your next post.