Hello Excel Team,
Please provide help to run the below with macro or sql...
I have a space seperated text file which has the following layout ...

ACCUM HAOPT ABSPRI ABSGRP OUTNM HABLIM HABTXT
ACCUM HHAOPT HHAPRI HHAGRP OUTNM HHALIM HHATXT
AIN ORAO ORAP ORAG ORAT
AIN HLOP HLPR HLGP ANM HAL HAT LAL LAT HLDB
AIN HHAOPT HHAPRI HHAGRP ANM HHALIM HHATXT LLALIM LLATXT HLDB
AIN BAO BAP BAG BAT
AINR ORAO ORAP ORAG ORAT
AINR HLOP HLPR HLGP ANM HAL HAT LAL LAT HLDB
AINR HHAOPT HHAPRI HHAGRP ANM HHALIM HHATXT LLALIM LLATXT HLDB
AINR BAO BAP BAG BAT
AOUT BAO BAP BAG BAT
AOUTR BAO BAP BAG BAT
BIAS MALOPT MEASPR MEASGR MEASNM MEASHL MEASHT MEASLL MEASLT
BIAS HHAOPT HHAPRI HHAGRP MEASNM HHALIM HHATXT LLALIM LLATXT MEASDB
BLNALM SAO_1 SAP_1 SAG_1 ANM_1 NM0_1 NM1_1 IVO_1
BLNALM SAO_2 SAP_2 SAG_2 ANM_2 NM0_2 NM1_2 IVO_2
BLNALM SAO_3 SAP_3 SAG_3 ANM_3 NM0_3 NM1_3 IVO_3
BLNALM SAO_4 SAP_4 SAG_4 ANM_4 NM0_4 NM1_4 IVO_4
BLNALM SAO_5 SAP_5 SAG_5 ANM_5 NM0_5 NM1_5 IVO_5
BLNALM SAO_6 SAP_6 SAG_6 ANM_6 NM0_6 NM1_6 IVO_6
BLNALM SAO_7 SAP_7 SAG_7 ANM_7 NM0_7 NM1_7 IVO_7
BLNALM SAO_8 SAP_8 SAG_8 ANM_8 NM0_8 NM1_8 IVO_8
CHARC ORAO ORAP ORAG ORAT
CIN SAO SAP SAG ANM NM0 NM1 IVO
CIN SCOPT ?????? SCGRP ANM SCTXT0 SCTXT1 IVO
CIN BAO BAP BAG BAT
COUT BAO BAP BAG BAT
DEP OP_OPT OP_PRI OP_GRP OP_TXT
DGAP MALOPT MEASPR MEASGR MEASNM MEASHL MEASHT MEASLL MEASLT
DGAP DALOPT DEVPRI DEVGRP MEASNM HDALIM HDATXT LDALIM LDATXT DEVADB
DGAP HHAOPT HHAPRI HHAGRP MEASNM HHALIM HHATXT LLALIM LLATXT MEASDB
DPIDA MALOPT MEASPR MEASGR MEASNM MEASHL MEASHT MEASLL MEASLT
DPIDA DALOPT DEVPRI DEVGRP MEASNM HDALIM HDATXT LDALIM LDATXT DEVADB
DPIDA HHAOPT HHAPRI HHAGRP MEASNM HHALIM HHATXT LLALIM LLATXT MEASDB
DPIDA OALOPT OUTPRI OUTGRP OUTNM HOALIM HOATXT LOALIM LOATXT OUTADB
EVENT XXXXXX EVPRI EVGRP
EVENT TAO TAP TAG TAT
EVENT BAO BAP BAG BAT
EXC OP_OPT OP_PRI OP_GRP OP_TXT
GDEV XXXXXX SAP SAG ANM MM1 MM2 MM3 MM4
GDEV BAO BAP BAG BAT
IND OP_OPT OP_PRI OP_GRP OP_TXT
MDACT MALOPT MEASPR MEASGR MEASNM MEASHL MEASHT MEASLL MEASLT
MDACT DALOPT DEVPRI DEVGRP MEASNM HDALIM HDATXT LDALIM LDATXT DEVADB
MDACT HHAOPT HHAPRI HHAGRP MEASNM HHALIM HHATXT LLALIM LLATXT MEASDB
MDACT OALOPT OUTPRI OUTGRP OUTNM HOALIM HOATXT LOALIM LOATXT OUTADB
MDACT BAO BAP BAG BAT
MEALM BAO BAP BAG BAT
MEALM XXXXXX MEASPR MEASGR PNM MEASHL HATXT MEASHL LATXT
MOVLV XXXXXX SAP SAG ANM NM0 NM1
MOVLV BAO BAP BAG BAT
MTR XXXXXX SAP SAG ANM NM0 NM1
MTR BAO BAP BAG BAT
MVL MALOPT MEASPR MEASGR MEASNM MEASHL MEASHT MEASLL MEASLT
MVL DALOPT DEVPRI DEVGRP MEASNM HDALIM HDATXT LDALIM LDATXT DEVADB
MVL HHAOPT HHAPRI HHAGRP MEASNM HHALIM HHATXT LLALIM LLATXT MEASDB
MVL OALOPT OUTPRI OUTGRP OUTNM HOALIM HOATXT LOALIM LOATXT OUTADB
PATALM MMAOPT SAP SAG ANM NM0 NM1
PID MALOPT MEASPR MEASGR MEASNM MEASHL MEASHT MEASLL MEASLT
PID DALOPT DEVPRI DEVGRP MEASNM HDALIM HDATXT LDALIM LDATXT DEVADB
PID HHAOPT HHAPRI HHAGRP MEASNM HHALIM HHATXT LLALIM LLATXT MEASDB
PID OALOPT OUTPRI OUTGRP OUTNM HOALIM HOATXT LOALIM LOATXT OUTADB
PIDA MALOPT MEASPR MEASGR MEASNM MEASHL MEASHT MEASLL MEASLT
PIDA DALOPT DEVPRI DEVGRP MEASNM HDALIM HDATXT LDALIM LDATXT DEVADB
PIDA HHAOPT HHAPRI HHAGRP MEASNM HHALIM HHATXT LLALIM LLATXT MEASDB
PIDA OALOPT OUTPRI OUTGRP OUTNM HOALIM HOATXT LOALIM LOATXT OUTADB
PIDX MALOPT MEASPR MEASGR MEASNM MEASHL MEASHT MEASLL MEASLT
PIDX DALOPT DEVPRI DEVGRP MEASNM HDALIM HDATXT LDALIM LDATXT DEVADB
PIDX HHAOPT HHAPRI HHAGRP MEASNM HHALIM HHATXT LLALIM LLATXT MEASDB
PIDX OALOPT OUTPRI OUTGRP OUTNM HOALIM HOATXT LOALIM LOATXT OUTADB
PIDE MALOPT MEASPR MEASGR MEASNM MEASHL MEASHT MEASLL MEASLT
PIDE DALOPT DEVPRI DEVGRP MEASNM HDALIM HDATXT LDALIM LDATXT DEVADB
PIDE HHAOPT HHAPRI HHAGRP MEASNM HHALIM HHATXT LLALIM LLATXT MEASDB
PIDE OALOPT OUTPRI OUTGRP OUTNM HOALIM HOATXT LOALIM LOATXT OUTADB
PIDXE MALOPT MEASPR MEASGR MEASNM MEASHL MEASHT MEASLL MEASLT
PIDXE DALOPT DEVPRI DEVGRP MEASNM HDALIM HDATXT LDALIM LDATXT DEVADB
PIDXE HHAOPT HHAPRI HHAGRP MEASNM HHALIM HHATXT LLALIM LLATXT MEASDB
PIDXE OALOPT OUTPRI OUTGRP OUTNM HOALIM HOATXT LOALIM LOATXT OUTADB
PTC MALOPT MEASPR MEASGR MEASNM MEASHL MEASHT MEASLL MEASLT
PTC DALOPT DEVPRI DEVGRP MEASNM HDALIM HDATXT LDALIM LDATXT DEVADB
PTC HHAOPT HHAPRI HHAGRP MEASNM HHALIM HHATXT LLALIM LLATXT MEASDB
RATIO MALOPT MEASPR MEASGR MEASNM MEASHL MEASHT MEASLL MEASLT
RATIO HHAOPT HHAPRI HHAGRP MEASNM HHALIM HHATXT LLALIM LLATXT MEASDB
REALM HLAOPT ABSPRI ABSGRP MEASNM HABLIM HABTXT LABLIM LABTXT ABSDB
REALM HHAOPT HHAPRI HHAGRP MEASNM HHALIM HHATXT LLALIM LLATXT ABSDB
REALM DALOPT DEVPRI DEVGRP MEASNM HDALIM HDATXT LDALIM LDATXT DEVADB
REALM ROCOPT ROCPRI ROCGRP MEASNM ROCLIM ROCTXT ROCTIM
STALM XXXXXX SAP SAG PNM SATXT RTNTXT
STALM BAO BAP BAG BAT
VLV XXXXXX SAP SAG ANM NM0 NM1
VLV BAO BAP BAG BAT

Now I want the Above to be imported to excel or access database and
R1C1 to remain in same line and R1C2 to R1C6 to shift to above line as
header.
sample as below, and R2C2 to R2C6 to move as header after the first
line header is placed and so on. and delete the R2(ACCUM) and the same
to continue for R3C1 until R91C1...

HAOPT ABSPRI ABSGRP HHAOPT HHAPRI HHAGRP ORA,ORAP,ORAO
ORAP.. ACCUM 4 5 9
AIN

Note :for example ACCUM,AIN,AINR,AOUT,AOUTR etc are type and assume
parameters as headers...
Now we have another CSV file which has parameter values in numerics
for HAOPT,ABSPRI,ABSGRP such as 4,5,9 ,These values needs to be copied
under the same header as shown above.
Is it possible to import or merge these files with the parameter
values.
Thx in advance...If not clear I can sent you text file and sample
excel file offlist.please provide ur mailid.
Ajit...Saudi Arabia