[Help Needed] From CSV Excel Experts to re-arrange data

Josh Butler

Jr. VIP
Jr. VIP
Joined
Aug 29, 2021
Messages
114
Reaction score
56
Time has come to pay our tax to the government. We have all the expenses and revenues exported in CSV columns. We are having a hard time in properly formatting the files to submit to the tax department.

Here, I would appreciate if someone is willing to shed some lights on how to do it.

We have the following CSV format (just demo)

RevenueExpense
month 1: +300 date: 01/01/01Month 1: -100 date: 01/01/01
+300 date: 02/01/01 -100 date: 02/01/01
+300 date: 03/01/01 -100 date: 03/01/01
Month 2: +400 date 01/02/01Month 2: -200 date: 01/02/01
+400 date 02/02/01 -200 date: 01/02/01
+400 date 01/02/01 -200 date: 01/02/01


We need to turn it to the following format:

Revenue Expense
month 1: +300 date: 01/01/01Month 1: -100 date: 01/01/01
+300 date: 02/01/01
-100 date: 02/01/01
+300 date: 03/01/01
-100 date: 03/01/01
Month 2: +400 date 01/02/01Month 2: -200 date: 01/02/01
+400 date 02/02/01
-200 date: 02/02/01
+400 date 03/02/01
-200 date: 03/02/01


We can do it manually but there are thousands of rows (literally 12 months of data)


So, if any body knows of any Excel Formula or Google Sheets Formula that can help us format, I would really appreciate it

we can easily rename the columns, if we could format in the desired format.
 

Josh Butler

Jr. VIP
Jr. VIP
Joined
Aug 29, 2021
Messages
114
Reaction score
56
We actually had different csv files for each months, But after searching it for few hours, I was able to combine all months data in one csv files.

Now, we need help in properly formatting it.

If needed, I'm also more than willing to pay to teach me, how to do it. Send me a PM
 

fb3003

Jr. VIP
Jr. VIP
Joined
Aug 14, 2015
Messages
4,032
Reaction score
2,593
Website
bit.ly
i suggest to show us a sample excel instead of the table. i am not sure if your table is clearly presenting your data structure or not.
 

Aleksandar916

Jr. VIP
Jr. VIP
Joined
Nov 29, 2017
Messages
567
Reaction score
801
Website
www.centperword.com
Yeah, you need to either give a sample or a screenshot. If the spreadsheet is really the way you've written it it's horribly designed.

Why do you want the specific outcome you've posted?
 
Top