+ Reply to Thread
Results 1 to 5 of 5

How to change row value to column value for same heading

  1. #1
    Registered User
    Join Date
    04-27-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2003
    Posts
    3

    Question How to change row value to column value for same heading

    Hi All,


    I have 1 question regarding converting XML files into XL sheet.
    I want to convert more than !00 XML files into 1 XL sheet for some comparison work.
    And want the format like this:

    Input:-

    Age Roll No. Name
    12 1111 AAA
    13 1234 bbb
    15 1235 ccc

    Output:
    Age Age Age Roll no. Roll no. Roll no. Name Name Name
    12 13 15 1111 1234 1235 AAA bbb ccc


    Please suggest some method for this.


    Thanking You,

    Regards,
    Priyanka Srivastava

  2. #2
    Valued Forum Contributor
    Join Date
    06-17-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003,excel 2007
    Posts
    678

    Re: How to change row value to column value for same heading

    see attached fiel "priyankja.xls"

    you see sheet 2 which is after macro was run

    for retesting rerun macro "test"

    the macro is available in the module of the file and also given here


    Please Login or Register  to view this content.
    Attached Files Attached Files
    I am not an expert. better solutions may be available
    [email protected]

  3. #3
    Registered User
    Join Date
    04-27-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: How to change row value to column value for same heading

    Hi Venkat,

    Thanxs for your valueable opinion.
    I tried running this macro but still some error came while running.
    Here I am sending the example of 1 XML file to which I want to convert in XL sheet with this format.

    <?xml version="1.0" encoding="UTF-8"?>
    <S:Envelope
    xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
    <S:Body>
    <ns2:makeDecisionResponse xmlns:ns2="http://capitalone.com/tai">
    <outputXML>
    <AppnDscnRespns AppnID="9609060571157460" xmlns="../schemas/PostBureauRq">
    <AsgndRandNums>
    <AsgndRandNum>424</AsgndRandNum>
    <RandNumName>HeadlineCPAsgnmntRN</RandNumName>
    </AsgndRandNums>
    <AsgndRandNums>
    <AsgndRandNum>166</AsgndRandNum>
    <RandNumName>AlternativeOfrCPRN</RandNumName>
    </AsgndRandNums>
    <AsgndRandNums>
    <AsgndRandNum>367</AsgndRandNum>
    <RandNumName>HSAcqFTLineRN</RandNumName>
    </AsgndRandNums>
    <AsgndRandNums>
    <AsgndRandNum>224</AsgndRandNum>
    <RandNumName>BTTeaserTestFluffRN</RandNumName>
    </AsgndRandNums>
    <AsgndRandNums>
    <AsgndRandNum>916</AsgndRandNum>
    <RandNumName>SecuritySumRN</RandNumName>
    </AsgndRandNums>
    <AsgndRandNums>
    <AsgndRandNum>328</AsgndRandNum>
    <RandNumName>LineAllocation1RN</RandNumName>
    </AsgndRandNums>
    <AsgndRandNums>
    <AsgndRandNum>246</AsgndRandNum>
    <RandNumName>LineAllocation2RN</RandNumName>
    </AsgndRandNums>
    <AsgndRandNums>
    <AsgndRandNum>965</AsgndRandNum>
    <RandNumName>LineAllocation3RN</RandNumName>
    </AsgndRandNums>
    <AsgndRandNums>
    <AsgndRandNum>774</AsgndRandNum>
    <RandNumName>LimitOverrideRN</RandNumName>
    </AsgndRandNums>
    <AsgndRandNums>
    <AsgndRandNum>378</AsgndRandNum>
    <RandNumName>SecuritySumOvrdRN</RandNumName>
    </AsgndRandNums>
    <AsgndRandNums>
    <AsgndRandNum>288</AsgndRandNum>
    <RandNumName>ExceptionRuleOvrdRN</RandNumName>
    </AsgndRandNums>
    <AppnDcsn>
    <PostBur>
    <AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE HIGHSTREET UTILISATION INDEX</ModelId>
    <IdxVal>1</IdxVal>
    </AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE RISK MODEL SEGMENT</ModelId>
    <SegVal>THICK</SegVal>
    </AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE THICK CONTRACTUAL MODEL SCORE</ModelId>
    <ScoreVal>327</ScoreVal>
    </AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE THICK ASSISTED MODEL SCORE</ModelId>
    <ScoreVal>431</ScoreVal>
    </AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE THICK COMBINED MODEL SCORE</ModelId>
    <ScoreVal>312</ScoreVal>
    </AppnModelRslts>
    AppnModelRslts>
    <ModelId>FUSE THIN MODEL SCORE</ModelId>
    <ScoreVal>-998</ScoreVal>
    </AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE OVERALL MODEL SCORE</ModelId>
    <ScoreVal>312</ScoreVal>
    </AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE UTILISATION MODEL GMENT</ModelId>
    <SegVal>UTIL</SegVal>
    </AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE UTILISATION MODEL SCORE</ModelId>
    <ScoreVal>-307</ScoreVal>
    </AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE CREDIT POLICY SEGMENT</ModelId>
    <SegVal>NCCJ</SegVal>
    </AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE UM BT SEGMENT</ModelId>
    <SegVal>BT No</SegVal>
    </AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE HIGHSTREET RISK INDEX</ModelId>
    <IdxVal>20</IdxVal>
    </AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE UPMARKET RISK INDEX</ModelId>
    <IdxVal>8</IdxVal>
    </AppnModelRslts>
    <ProdsAvl>
    <ProdOfrPrefncNum>0</ProdOfrPrefncNum>
    <ProdBusLineCd>HS</ProdBusLineCd>
    <UpslDwnslCrsSellCd>DS</UpslDwnslCrsSellCd>
    <ProdScorcdDcsnCd>AC01</ProdScorcdDcsnCd>
    <ProdLineOfrdAmt>500</ProdLineOfrdAmt>
    <CrLineAlocdAmt>500</CrLineAlocdAmt>
    <MaxCrLmtAmt>500</MaxCrLmtAmt>
    <CrLmtOpenToBuyAmt>500</CrLmtOpenToBuyAmt>
    <CrLmtFlfAmt>0</CrLmtFlfAmt>
    <ProdScurtOfrdAmt>0.0</ProdScurtOfrdAmt>
    <RqstdScurtSumAmt>0.0</RqstdScurtSumAmt>
    <BalTrfrLmtAmt>0</BalTrfrLmtAmt>
    <CashAdvLmtAmt>0</CashAdvLmtAmt>
    <PrchLmtAmt>0</PrchLmtAmt>
    <CrPlcyCd>A1</CrPlcyCd>
    <ProdCnstrctId>12060</ProdCnstrctId>
    <TermsConds>
    <TermsCondsBrndCd>0</TermsCondsBrndCd>
    <TermsCondsSellCd>405</TermsCondsSellCd>
    <TermsCondsSctn10Cd>405</TermsCondsSctn10Cd>
    <TermsCondsSmlPrntCd>405</TermsCondsSmlPrntCd>
    <TermsCondsFeesCd>6</TermsCondsFeesCd>
    </TermsConds>
    <RefRuleSetId>HS</RefRuleSetId>
    <ProdPrgrn>
    <FinlAutomdDcsnCd>accept</FinlAutomdDcsnCd>
    <InstDcsnInd>true</InstDcsnInd>
    <ReflQueCd></ReflQueCd>
    <PrimReasCd>AC01</PrimReasCd>
    </ProdPrgrn>
    </ProdsAvl>
    <ProdsAvl>
    <ProdOfrPrefncNum>1</ProdOfrPrefncNum>
    <ProdBusLineCd>UM</ProdBusLineCd>
    <UpslDwnslCrsSellCd>AP</UpslDwnslCrsSellCd>
    <ProdScorcdDcsnCd>AC01</ProdScorcdDcsnCd>
    <ProdLineOfrdAmt>4000</ProdLineOfrdAmt>
    <CrLineAlocdAmt>4000</CrLineAlocdAmt>
    <MaxCrLmtAmt>4000</MaxCrLmtAmt>
    <CrLmtOpenToBuyAmt>4000</CrLmtOpenToBuyAmt>
    <CrLmtFlfAmt>0</CrLmtFlfAmt>
    <ProdScurtOfrdAmt>0.0</ProdScurtOfrdAmt>
    <RqstdScurtSumAmt>0.0</RqstdScurtSumAmt>
    <BalTrfrLmtAmt>0</BalTrfrLmtAmt>
    <CashAdvLmtAmt>0</CashAdvLmtAmt>
    <PrchLmtAmt>0</PrchLmtAmt>
    <CrPlcyCd>FA1</CrPlcyCd>
    <ProdCnstrctId>1</ProdCnstrctId>
    <RefRuleSetId>UM</RefRuleSetId>
    <ProdPrgrn>
    <FinlAutomdDcsnCd>accept</FinlAutomdDcsnCd>
    <InstDcsnInd>true</InstDcsnInd>
    <ReflQueCd></ReflQueCd>
    <PrimReasCd>AC01</PrimReasCd>
    </ProdPrgrn>
    </ProdsAvl>
    <AMLData>
    <TotAMLRsidncyCnt>4</TotAMLRsidncyCnt>
    <TotAMLIDCnt>1</TotAMLIDCnt>
    </AMLData>
    </PostBur>
    </AppnDcsn>
    </AppnDscnRespns>
    </outputXML>
    </ns2:makeDecisionResponse>
    </S:Body>
    </S:Envelope>

    Thanking You,

    Priyanka Srivastava

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,445

    Re: How to change row value to column value for same heading

    Perhpas
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    04-27-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: How to change row value to column value for same heading

    Hi Jindon,

    Thanxs for your valued contribution but still when i am runnunig this macro it is not running.
    I have to convert this typeof XML file in to XL sheet.
    <?xml version="1.0" encoding="UTF-8"?>
    <S:Envelope
    xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
    <S:Body>
    <ns2:makeDecisionResponse xmlns:ns2="http://capitalone.com/tai">
    <outputXML>
    <AppnDscnRespns AppnID="9609060571157460" xmlns="../schemas/PostBureauRq">
    <AsgndRandNums>
    <AsgndRandNum>424</AsgndRandNum>
    <RandNumName>HeadlineCPAsgnmntRN</RandNumName>
    </AsgndRandNums>
    <AsgndRandNums>
    <AsgndRandNum>166</AsgndRandNum>
    <RandNumName>AlternativeOfrCPRN</RandNumName>
    </AsgndRandNums>
    <AsgndRandNums>
    <AsgndRandNum>367</AsgndRandNum>
    <RandNumName>HSAcqFTLineRN</RandNumName>
    </AsgndRandNums>
    <AsgndRandNums>
    <AsgndRandNum>224</AsgndRandNum>
    <RandNumName>BTTeaserTestFluffRN</RandNumName>
    </AsgndRandNums>
    <AsgndRandNums>
    <AsgndRandNum>916</AsgndRandNum>
    <RandNumName>SecuritySumRN</RandNumName>
    </AsgndRandNums>
    <AsgndRandNums>
    <AsgndRandNum>328</AsgndRandNum>
    <RandNumName>LineAllocation1RN</RandNumName>
    </AsgndRandNums>
    <AsgndRandNums>
    <AsgndRandNum>246</AsgndRandNum>
    <RandNumName>LineAllocation2RN</RandNumName>
    </AsgndRandNums>
    <AsgndRandNums>
    <AsgndRandNum>965</AsgndRandNum>
    <RandNumName>LineAllocation3RN</RandNumName>
    </AsgndRandNums>
    <AsgndRandNums>
    <AsgndRandNum>774</AsgndRandNum>
    <RandNumName>LimitOverrideRN</RandNumName>
    </AsgndRandNums>
    <AsgndRandNums>
    <AsgndRandNum>378</AsgndRandNum>
    <RandNumName>SecuritySumOvrdRN</RandNumName>
    </AsgndRandNums>
    <AsgndRandNums>
    <AsgndRandNum>288</AsgndRandNum>
    <RandNumName>ExceptionRuleOvrdRN</RandNumName>
    </AsgndRandNums>
    <AppnDcsn>
    <PostBur>
    <AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE HIGHSTREET UTILISATION INDEX</ModelId>
    <IdxVal>1</IdxVal>
    </AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE RISK MODEL SEGMENT</ModelId>
    <SegVal>THICK</SegVal>
    </AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE THICK CONTRACTUAL MODEL SCORE</ModelId>
    <ScoreVal>327</ScoreVal>
    </AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE THICK ASSISTED MODEL SCORE</ModelId>
    <ScoreVal>431</ScoreVal>
    </AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE THICK COMBINED MODEL SCORE</ModelId>
    <ScoreVal>312</ScoreVal>
    </AppnModelRslts>
    AppnModelRslts>
    <ModelId>FUSE THIN MODEL SCORE</ModelId>
    <ScoreVal>-998</ScoreVal>
    </AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE OVERALL MODEL SCORE</ModelId>
    <ScoreVal>312</ScoreVal>
    </AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE UTILISATION MODEL GMENT</ModelId>
    <SegVal>UTIL</SegVal>
    </AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE UTILISATION MODEL SCORE</ModelId>
    <ScoreVal>-307</ScoreVal>
    </AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE CREDIT POLICY SEGMENT</ModelId>
    <SegVal>NCCJ</SegVal>
    </AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE UM BT SEGMENT</ModelId>
    <SegVal>BT No</SegVal>
    </AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE HIGHSTREET RISK INDEX</ModelId>
    <IdxVal>20</IdxVal>
    </AppnModelRslts>
    <AppnModelRslts>
    <ModelId>FUSE UPMARKET RISK INDEX</ModelId>
    <IdxVal>8</IdxVal>
    </AppnModelRslts>
    <ProdsAvl>
    <ProdOfrPrefncNum>0</ProdOfrPrefncNum>
    <ProdBusLineCd>HS</ProdBusLineCd>
    <UpslDwnslCrsSellCd>DS</UpslDwnslCrsSellCd>
    <ProdScorcdDcsnCd>AC01</ProdScorcdDcsnCd>
    <ProdLineOfrdAmt>500</ProdLineOfrdAmt>
    <CrLineAlocdAmt>500</CrLineAlocdAmt>
    <MaxCrLmtAmt>500</MaxCrLmtAmt>
    <CrLmtOpenToBuyAmt>500</CrLmtOpenToBuyAmt>
    <CrLmtFlfAmt>0</CrLmtFlfAmt>
    <ProdScurtOfrdAmt>0.0</ProdScurtOfrdAmt>
    <RqstdScurtSumAmt>0.0</RqstdScurtSumAmt>
    <BalTrfrLmtAmt>0</BalTrfrLmtAmt>
    <CashAdvLmtAmt>0</CashAdvLmtAmt>
    <PrchLmtAmt>0</PrchLmtAmt>
    <CrPlcyCd>A1</CrPlcyCd>
    <ProdCnstrctId>12060</ProdCnstrctId>
    <TermsConds>
    <TermsCondsBrndCd>0</TermsCondsBrndCd>
    <TermsCondsSellCd>405</TermsCondsSellCd>
    <TermsCondsSctn10Cd>405</TermsCondsSctn10Cd>
    <TermsCondsSmlPrntCd>405</TermsCondsSmlPrntCd>
    <TermsCondsFeesCd>6</TermsCondsFeesCd>
    </TermsConds>
    <RefRuleSetId>HS</RefRuleSetId>
    <ProdPrgrn>
    <FinlAutomdDcsnCd>accept</FinlAutomdDcsnCd>
    <InstDcsnInd>true</InstDcsnInd>
    <ReflQueCd></ReflQueCd>
    <PrimReasCd>AC01</PrimReasCd>
    </ProdPrgrn>
    </ProdsAvl>
    <ProdsAvl>
    <ProdOfrPrefncNum>1</ProdOfrPrefncNum>
    <ProdBusLineCd>UM</ProdBusLineCd>
    <UpslDwnslCrsSellCd>AP</UpslDwnslCrsSellCd>
    <ProdScorcdDcsnCd>AC01</ProdScorcdDcsnCd>
    <ProdLineOfrdAmt>4000</ProdLineOfrdAmt>
    <CrLineAlocdAmt>4000</CrLineAlocdAmt>
    <MaxCrLmtAmt>4000</MaxCrLmtAmt>
    <CrLmtOpenToBuyAmt>4000</CrLmtOpenToBuyAmt>
    <CrLmtFlfAmt>0</CrLmtFlfAmt>
    <ProdScurtOfrdAmt>0.0</ProdScurtOfrdAmt>
    <RqstdScurtSumAmt>0.0</RqstdScurtSumAmt>
    <BalTrfrLmtAmt>0</BalTrfrLmtAmt>
    <CashAdvLmtAmt>0</CashAdvLmtAmt>
    <PrchLmtAmt>0</PrchLmtAmt>
    <CrPlcyCd>FA1</CrPlcyCd>
    <ProdCnstrctId>1</ProdCnstrctId>
    <RefRuleSetId>UM</RefRuleSetId>
    <ProdPrgrn>
    <FinlAutomdDcsnCd>accept</FinlAutomdDcsnCd>
    <InstDcsnInd>true</InstDcsnInd>
    <ReflQueCd></ReflQueCd>
    <PrimReasCd>AC01</PrimReasCd>
    </ProdPrgrn>
    </ProdsAvl>
    <AMLData>
    <TotAMLRsidncyCnt>4</TotAMLRsidncyCnt>
    <TotAMLIDCnt>1</TotAMLIDCnt>
    </AMLData>
    </PostBur>
    </AppnDcsn>
    </AppnDscnRespns>
    </outputXML>
    </ns2:makeDecisionResponse>
    </S:Body>
    </S:Envelope>

    Please suggest some method for converting this XML into XL sheet having hat format

    Regards,
    Priyanka

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1