Phoenix - Your AI AssistantMS Excel Help
- Posted:
- Proposals: 13
- Remote
- #3559971
- Awarded
Bhaktapur 
Description
Experience Level: Entry
Hi,
I am looking for some help with excel, I think you can probably do this with a formula, but I dont know how.
- I have around 1101 rows of data
- 3 rows make up one complete data record for this project (columns A-H on each row)
- I want to combine these three rows of data to show on one row (columns A-X), meaning I eventually have 367 rows
I can obviously cut and paste this but it will take me ages, is there an easy way to do this?
Thanks
James
I am looking for some help with excel, I think you can probably do this with a formula, but I dont know how.
- I have around 1101 rows of data
- 3 rows make up one complete data record for this project (columns A-H on each row)
- I want to combine these three rows of data to show on one row (columns A-X), meaning I eventually have 367 rows
I can obviously cut and paste this but it will take me ages, is there an easy way to do this?
Thanks
James
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Excel has a =CONCAT() function that will allow you to do this.