Forum

Forums
Public Forums - For...
General Excel Quest...
To Flat file data
 
Notifications
Clear all

To Flat file data

 
General Excel Questions & Answers
Last Post by Aye Mu 6 years ago
9 Posts
3 Users
0 Reactions
228 Views
RSS
 Aye Mu
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Hi Team,

I just have to transform my file to Flat File data. 

I have so many columns and having additional columns time by time.

Over the period, I may have additional lines as well as redundant lines. The only thing it will be fixed is Bands for the facilities are aligning according to the P&L category.

Please see attached data and expected result.

Thank you so much.

Regards,

Aye

 
Posted : 27/03/2019 11:22 pm
 SunnyKow
(@sunnykow)
Posts: 1417
Noble Member
 

There is no attachment

 
Posted : 27/03/2019 11:51 pm
 Aye Mu
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Opp! sorry,

Please see attached, Sunny.

Thank you.

Regards,

Aye

 
Posted : 28/03/2019 1:21 am
 SunnyKow
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Aye Mu

You can give this a try first.

No time to look into the formatting of the output.

Hope this helps.

Sunny

 
Posted : 28/03/2019 4:54 am
 SunnyKow
(@sunnykow)
Posts: 1417
Noble Member
 

This is the updated version including number formatting.

Good luck

 
Posted : 28/03/2019 11:35 am
 Aye Mu
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Thank you so much, Sunny,

It works perfect on my data.

I would like to learn VBA. Is there any course you recommend?

Regards,

Aye

 
Posted : 28/03/2019 6:10 pm
 Mynda Treacy
(@mynda)
Posts: 4766
Member Admin
 

Hi Aye,

I recommend this VBA course.

Mynda

 
Posted : 28/03/2019 6:56 pm
 SunnyKow
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Aye

Go with what Mynda suggested.

Sunny

 
Posted : 28/03/2019 7:24 pm
 Aye Mu
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Thanks, Mynda and Sunny.

Regards,

Aye

 
Posted : 28/03/2019 8:30 pm
Forum Jump:
  Previous Topic
Next Topic  
Share: