Convert datagrid data to raw data

[Closed]
Report
Posts
4
Registration date
Tuesday March 4, 2014
Status
Member
Last seen
March 4, 2014
-
Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
-
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

Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
481
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
Posts
4
Registration date
Tuesday March 4, 2014
Status
Member
Last seen
March 4, 2014

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
Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
481
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?
Posts
4
Registration date
Tuesday March 4, 2014
Status
Member
Last seen
March 4, 2014

i dont think so. can i send an excel file ?
Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
481
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
Posts
4
Registration date
Tuesday March 4, 2014
Status
Member
Last seen
March 4, 2014

i've sent you the file to the rely to email,

can you please check it.

thanks,
Joao
Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
481
I will look at your file, when you post back the download link in your next post.