Forum

Notifications
Clear all

Data Transpose in excel

5 Posts
3 Users
0 Reactions
463 Views
(@mallikarjun)
Posts: 3
Active Member
Topic starter
 

Dear Mynda, rn                 Below i attached excel sample file.rn          rn rn 


 
Posted : 12/11/2022 10:04 am
(@mynda)
Posts: 4783
Member Admin
 

Hi Mesa,

Welcome to our forum!

Your file did not upload. After selecting the file, you need to click the 'Upload' button and then wait for the grey check mark beside the file size before clicking Submit Reply.

Mynda


 
Posted : 13/11/2022 1:18 am
(@mallikarjun)
Posts: 3
Active Member
Topic starter
 

Hi Mynda,

 

Below attached excel sample file....


 
Posted : 13/11/2022 7:45 am
Anders Sehlstedt
(@sehlsan)
Posts: 986
Noble Member
 

Hello Mesa,

Please see the attached modified copy of your sample file, hopefully I have added some useful tips on how to solve your problem.

When working with data in tables it is best to have the data in a tabular format, it gets a lot easier to write formulas and add PivotTables.

Br,
Anders


 
Posted : 14/11/2022 1:29 pm
(@mallikarjun)
Posts: 3
Active Member
Topic starter
 

Hi Anders,

                Thanks for updating with alternative solutions.....Really heled a lot...

 

Thanks

Mesa


 
Posted : 15/11/2022 2:32 am
Share:
0