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 January 16, 2023 - 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 replies

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
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
0
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
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
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 January 16, 2023 544
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
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
Mar 6, 2014 at 10:25 AM
I will look at your file, when you post back the download link in your next post.
0