Convert Cross Table to Panel Table Data in Excel

I need person who can convert crosstab data to panel data in excel. Screenshot 1 illustrates the basic point. My data right now looks like Blue table (with blanks between rows) and I need it to look as Green table. Second screenshot shows how the actual workfile looks like. My datafiles are large and I need to convert around 40 sheets of data (with data structured a bit differently on each sheet) overall. The person needs to either convert all of it or provide me with elegant decision to quickly do it myself.


Taidot: tiedonsyöttö, tietojenkäsittely, Excel

Näytä lisää: convert $50, bit of data, data structured, data in, data entry in excel sheets, data entry excel sheets, blue cross, convert quickly, elegant excel, excel sheet large data entry, convert xml excel table, entry data sheet excel, convert raw excel table data pivot table results, shows excel, convert word excel table, cross table, convert table excel, word table convert excel table, convert dat file excel table, convert word table excel table including format

Tietoa työnantajasta:
( 1 arvostelu ) Rotterdam, Netherlands

Projektin tunnus: #7541585

Myönnetty käyttäjälle:


I am a professional data analyst and researcher for the University of California, Berkeley. I would complete the tasks quickly and accurately, and provide you with excellent documentation and results at the end of the Lisää

€99 EUR 3 päivässä
(2 Arvostelua)

25 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


A proposal has not yet been provided

€70 EUR 0 päivässä
(170 arvostelua)

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, databases and macros. Check my reviews. They speak for themselves. Best regar Lisää

€122 EUR 5 päivässä
(44 arvostelua)

Hi, I would love to work on this project. I have 8 years of experience in Microsoft Excel including working with excel modeling, dashboards and macros. I can start right now. Please contact with further details if Lisää

€111 EUR 3 päivässä
(47 arvostelua)

Hello Dear, Sir/Madam, HERE Ready to start Now!!! I can perfectly do it and interested for this project. Have an experience same and different types of projects. I am waiting to your quick positive reply. Fee Lisää

€105 EUR 3 päivässä
(63 arvostelua)

Hell again, checked your file we may find some solutions using macros and/or a combination of macros and manual work, can you please send me your excel file since I did not know what type of cross tab data is your seco Lisää

€89 EUR 3 päivässä
(73 arvostelua)

Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have b Lisää

€100 EUR 1 päivässä
(11 arvostelua)

Hello Sir. I have see your scrrenshot and i think i can do it fast via macro VBA :) please give me a chance for doing your job and im able to start doing your job right now :) please see my portfolio and my feedba Lisää

€30 EUR 0 päivässä
(46 arvostelua)

ABOUT US "IT FLEX SOLUTIONS has focused exclusively on the Web Development/Designing projects with 8+ years of service. Our Web Development/Designing expertise has helped clients to create e-commerce, social networkin Lisää

€100 EUR 1 päivässä
(3 arvostelua)

Hello, The first part is understandable. I can realize it (using macro) within a few hours. The second part Screenshot 2 - requires explanation. It is not clear to me what to do. Can you write something more on this Lisää

€100 EUR 3 päivässä
(10 arvostelua)

Hello Sir/Miss My name is Noman Gulzar and I am a Graphics design Contrator located in Karachi Pakistan. I would love to have the opportunity to interview with you about your posting. I have completed a wide variety o Lisää

€105 EUR 3 päivässä
(8 arvostelua)

Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene

€66 EUR 2 päivässä
(16 arvostelua)

Hi it is very simple thing. Just you need to copy it and paste it as special. Very simple thing you can do by your self. If you have doubts i will help you. Don't waste your money unnecessarily. Regards, Bhaskar

€30 EUR 3 päivässä
(2 arvostelua)

Hi! I have VBA codes ready for your project. Can you contact me so that I give you some samples? Thanks

€111 EUR 1 päivässä
(1 arvostelu)

I am Anbu Joseph from India. I have excellent experience in data entry works and Web researching. I have completed my MCA-master graduate degree in computer applications. Moreover fast typing, excel, Web researching, Lisää

€30 EUR 1 päivässä
(1 arvostelu)

A proposal has not yet been provided

€240 EUR 42 päivässä
(0 arvostelua)

Hi, I work in excel for nearly 20 years. I have advanced skills in complex excel formulas, VBA, XML data files. I am a business consultant, i know the importance of details. Currently i am contributing with solutions Lisää

€155 EUR 3 päivässä
(0 arvostelua)

A proposal has not yet been provided

€30 EUR 0 päivässä
(0 arvostelua)

A proposal has not yet been provided

€155 EUR 3 päivässä
(0 arvostelua)

I know Excel very well, I like it so much :) I will be able to take into account all your wishes After the project I will be happy to consult you on matters of Excel

€133 EUR 3 päivässä
(0 arvostelua)

The work could be done. I've got what exactly you are looking for. I can do all the conversions within the time period asked by me. For details, kindly contact so that we could discuss further. Thanks

€222 EUR 2 päivässä
(0 arvostelua)