+ Reply to Thread
Results 1 to 6 of 6

Data Transfer Row to Column

  1. 11-22-2018, 09:49 PM #1
    coryspeth
    coryspeth is offline
    Registered User
    Join Date
    10-04-2018
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    16

    Data Transfer Row to Column

    Hi,

    I need some help with this.

    On sheet2 I have a matrix of data that needs to be converted into 2 columns on sheet1. Column 2 on sheet1 is pretty much a concatenate of sheet the header in sheet2 and the value.

    Attached is a sample.

    Thanks.
    Attached Files Attached Files
    Last edited by coryspeth; 11-22-2018 at 09:52 PM.
    Reply With QuoteRegister To Reply
  2. 11-22-2018, 10:01 PM #2
    kersplash
    kersplash is offline
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Data Transfer Row to Column

    I solved this with Power Query in the attached.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 11-22-2018, 11:04 PM #3
    coryspeth
    coryspeth is offline
    Registered User
    Join Date
    10-04-2018
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    16

    Re: Data Transfer Row to Column

    Thank you. Unfortunately I would prefer this to work through standard excel vbas. Would it be possible with some and concatenate lines?
    Reply With QuoteRegister To Reply
  4. 11-23-2018, 12:02 AM #4
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Data Transfer Row to Column

    Only for the data provided.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 11-23-2018, 01:30 AM #5
    coryspeth
    coryspeth is offline
    Registered User
    Join Date
    10-04-2018
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    16

    Re: Data Transfer Row to Column

    Thanks Jin Din! Unfortunately looks like yours is Sheet 1 > Sheet 2. I need Sheet 2 -> Sheet 1. At least i know its possible now !
    Reply With QuoteRegister To Reply
  6. 11-23-2018, 01:38 AM #6
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Data Transfer Row to Column

    Other way around?

    Then simply...
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Transfer formula for data entered on one column to another tab/column
    By weaverswonders6 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-10-2014, 11:48 AM
  2. Need Formula to Transfer Column Data to another Column; Omitting Cells with no data
    By LotoBoost in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-17-2013, 09:59 AM
  3. Need Formula to Transfer Column Data to another Column; But Omit Cells with no data
    By LotoBoost in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-12-2013, 04:00 PM
  4. how do i get data to automatically transfer to diff column each time new data entered
    By Phx2010 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-13-2011, 05:37 PM
  5. Excel 2007 : Transfer data IN COLUMN TO ROW
    By mkmed in forum Excel General
    Replies: 2
    Last Post: 06-15-2010, 12:18 PM
  6. How to transfer data from column to row
    By Aramis_P in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2009, 03:06 AM
  7. Data to transfer from column to row
    By qwerty70 in forum Excel General
    Replies: 2
    Last Post: 03-21-2006, 09:00 AM

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1