Previous Topic Next Topic

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

Answer 1 / 4
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
0
Answer 2 / 4
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 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
Answer 3 / 4
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
Answer 4 / 4
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.
0

Similar discussions

AMD data change update new data to DMI
Luis -
dwebb -

1 response
Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses
Hosted app data will not clear
Woody_3336 -
woody_3336 -

7 responses