Skip to main content
Solved

How to transpose an excel sheet, but only a couple of columns.

  • September 17, 2019
  • 2 replies
  • 4 views

mcgregrr
Contributor
Forum|alt.badge.img+1

I have a logger output excel spreadsheet where the easting, northing, height, and sensor value are in one column but I need them each to be an independent column. So I need to add four new columns to the excel and populate them from the one column while leaving the loggercode and dateutcdate alone.

Best answer by takashi

Hi @mcgregrr, this screenshot illustrates a possible way. Hope this helps.

View original
Did this help you find an answer to your question?

2 replies

takashi
Influencer
  • Best Answer
  • September 17, 2019

Hi @mcgregrr, this screenshot illustrates a possible way. Hope this helps.


mcgregrr
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • September 18, 2019

Thank you takashi... that worked well.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings