Results 1 to 5 of 5

Thread: Transpose A Column Of Data In To A Table

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 05-19-2013, 08:32 PM #1
    gunjan.nasit
    gunjan.nasit is offline
    Junior Member
    Join Date
    May 2013
    Posts
    3
    Rep Power
    0

    Transpose A Column Of Data In To A Table

    i have to transpose the column data in to row.

    in this data the first cell data is of font size 13.5 after that some cells are of font size 10 after that further one cell of font size 13.5 and another are of font 10.....

    I have to do transpose this column data in such away that
    first cell of 13.5 size data will copy in sheet 2 A1, further data of size 10 will copied to B1, C1, D1....till the second 13.5 sized cell came.
    when the 13.5 sized cell came in recognition it will copied to A2, further data of size 10 will copied to B2, C2, D2....till the second 13.5 sized cell came, and continued to the end of the data.....

    i have attached format for desired data transpose as i have described in red font in excel
    Please, help me out for this problem by Macro/VBA code.....

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.eileenslounge.com/viewtopic.php?f=44&t=40455&p=313035#p313035
    https://www.eileenslounge.com/viewtopic.php?f=18&t=40411&p=312889#p312889
    https://www.eileenslounge.com/viewtopic.php?f=18&t=40411&p=312886#p312886
    https://www.eileenslounge.com/viewtopic.php?f=18&t=40411&p=312752#p312752
    https://www.eileenslounge.com/viewtopic.php?f=18&t=40411&p=312734#p312734
    https://www.eileenslounge.com/viewtopic.php?f=18&t=40411&p=312727#p312727
    https://www.eileenslounge.com/viewtopic.php?f=18&t=40411&p=312724#p312724
    https://www.eileenslounge.com/viewtopic.php?f=44&t=40374&p=312535#p312535
    https://www.eileenslounge.com/viewtopic.php?p=312533#p312533
    https://www.eileenslounge.com/viewtopic.php?f=44&t=40373&p=312499#p312499
    https://www.youtube.com/watch?v=jTmVtPHtiTg&lc=Ugy_RiNN_kAqUvZ8W994AaABAg. 9xhyRrsUUOM9xpn-GDkL3o
    https://www.youtube.com/watch?v=jTmVtPHtiTg&lc=Ugy_RiNN_kAqUvZ8W994AaABAg
    https://www.youtube.com/watch?v=jTmVtPHtiTg&lc=UgzlC5LBazG6SMDP4nl4AaABAg
    https://www.youtube.com/watch?v=jTmVtPHtiTg&lc=UgzlC5LBazG6SMDP4nl4AaABAg. 9zYoeePv8sZ9zYqog9KZ5B
    https://www.youtube.com/watch?v=jTmVtPHtiTg&lc=Ugy_RiNN_kAqUvZ8W994AaABAg. 9xhyRrsUUOM9zYlZPKdOpm
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Attached Files Attached Files
    Last edited by DocAElstein; 03-01-2024 at 03:04 PM. Reason: correction
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Redistribute a Delimited Column Of Data into Separate Rows (Keeping Other Data As Is)
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 34
    Last Post: 03-13-2015, 02:26 PM
  2. data Transpose in VBA loop, choose the part I want to import!
    By esther723 in forum Excel Help
    Replies: 2
    Last Post: 04-16-2013, 01:36 PM
  3. Transpose Multiple columns data into multiple rows
    By manoj in forum Excel Help
    Replies: 2
    Last Post: 06-14-2012, 04:10 AM
  4. Transpose data into Rows
    By vikash200418 in forum Excel Help
    Replies: 2
    Last Post: 04-10-2012, 11:02 PM
  5. Pivot Table assistance : (How to use column headers in report filter in PT)
    By excel_learner in forum Excel Help
    Replies: 9
    Last Post: 03-13-2012, 01:27 PM

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
  •  

Forum Rules