How to Update header with above row if Blank

Question

deHi All,

I have been trying to build a solution to make the header standard. I get an input file in which I have to some manual adjustments to get the expected header. below are the snap of input and expected output. Please let me know if anyone know how it can be done.

Input      MonthJan  Mar  Feb  Apr  Jun  Jul  FirstNameLastNameAddressCityRegionPostalCodeCountryPhoneamtTaxDateamtTaxDateamtTaxDateamtTaxDateamtTaxDateamtTaxDateBobAllen130 17th St.VancouverBCV4T 1Y9Canada(604) 555-0192973506-05-2022574906-05-2022897906-05-2022761106-05-202281706-05-2022937606-05-2022NickAshton89 Cedar WayRedmondWA88052USA(425) 555-0191714206-05-2022147206-05-2022701706-05-2022295106-05-2022967706-05-2022274406-05-2022JuliaBergPO Box 69YakimaWA88902USA(509) 555-0188392606-05-2022345506-05-2022471706-05-202267806-05-2022801906-05-2022655606-05-2022JackBoseman55 Grizzly Peak Rd.ButteMT49707USA(406) 555-0186163706-05-2022754906-05-202228706-05-202278706-05-202245706-05-2022371506-05-2022JohnCampbell22 Market St.San FranciscoCA84112USA(415) 555-0183159706-05-2022919706-05-2022162106-05-2022547706-05-2022576406-05-2022731506-05-2022SamCannon89 W. Hilltop Dr.Palo AltoCA84306USA(415) 555-0182332306-05-20221002606-05-2022567006-05-202299806-05-2022136306-05-2022787506-05-2022DeanFunk1815 Yolo St.SeattleWA88117USA(425) 555-0166552206-05-2022228806-05-2022435006-05-2022987106-05-2022216406-05-2022724706-05-2022                                                                                                                                                                                      Output      MonthJanJanJanMarMarMarFebFebFebAprAprAprJunJunJunJulJulJulFirstNameLastNameAddressCityRegionPostalCodeCountryPhoneamt_JanTax_JanDate_Janamt_MarTax_MarDate_Maramt_FebTax_FebDate_Febamt_AprTax_AprDate_Apramt_JunTax_JunDate_Junamt_JulTax_JulDate_JulBobAllen130 17th St.VancouverBCV4T 1Y9Canada(604) 555-0192973506-05-2022574906-05-2022897906-05-2022761106-05-202281706-05-2022937606-05-2022NickAshton89 Cedar WayRedmondWA88052USA(425) 555-0191714206-05-2022147206-05-2022701706-05-2022295106-05-2022967706-05-2022274406-05-2022JuliaBergPO Box 69YakimaWA88902USA(509) 555-0188392606-05-2022345506-05-2022471706-05-202267806-05-2022801906-05-2022655606-05-2022JackBoseman55 Grizzly Peak Rd.ButteMT49707USA(406) 555-0186163706-05-2022754906-05-202228706-05-202278706-05-202245706-05-2022371506-05-2022JohnCampbell22 Market St.San FranciscoCA84112USA(415) 555-0183159706-05-2022919706-05-2022162106-05-2022547706-05-2022576406-05-2022731506-05-2022SamCannon89 W. Hilltop Dr.Palo AltoCA84306USA(415) 555-0182332306-05-20221002606-05-2022567006-05-202299806-05-2022136306-05-2022787506-05-2022DeanFunk1815 Yolo St.SeattleWA88117USA(425) 555-0166552206-05-2022228806-05-2022435006-05-2022987106-05-2022216406-05-2022724706-05-2022

.

binu_acs · Accepted Answer

@Mukeshy12390 one way of doing this

flying008 · Accepted Answer

Hi, @Mukeshy12390

Dear, there is 2 solutions for you.

1- Common workflow, maybe have complex steps.

2- use macro like crew, but this way is so easy !