siddhuprince86
New Member
Hai guys ,
I have been working on Store and inventory data base at my work place ,
I have created a user form which can capture all the details of the supplier and transfers into excel ,
when transferring into the excel format , some heads (columns) are few details to capture and few heads (columns) are having which we need to capture the details ,
which are been captured as below,
when you see the above table , material(column) has captured the data into 4 separate rows and which is needed for the hour , coming to other heads details are captured in single row , here how can i merge the above rows in Postal code,Maid ID,FAX NO,Mobile No,contact person,designation as on rows , which will look legible ,
and this should happen every four rows once ,
I have been working on Store and inventory data base at my work place ,
I have created a user form which can capture all the details of the supplier and transfers into excel ,
when transferring into the excel format , some heads (columns) are few details to capture and few heads (columns) are having which we need to capture the details ,
which are been captured as below,
| Postal Code | Mail ID | Fax No | Mobile No | Contact person | Designation | Material |
| fsdfsdf | ||||||
| fsdfsdf | ||||||
| fsfsdfs | ||||||
32323 | Siddhuprince@gmail.com | 8878 | 8768786 | hjghsgjhaf | sdfsdfsfd | sdfsf |
when you see the above table , material(column) has captured the data into 4 separate rows and which is needed for the hour , coming to other heads details are captured in single row , here how can i merge the above rows in Postal code,Maid ID,FAX NO,Mobile No,contact person,designation as on rows , which will look legible ,
and this should happen every four rows once ,
