Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Help switch rows to columns based on criteruim Help switch rows to columns based on criteruim
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 02-21-2022, 02:29 AM
allex011 allex011 is offline Help switch rows to columns based on criteruim Windows 7 32bit Help switch rows to columns based on criteruim Office 2007
Advanced Beginner
Help switch rows to columns based on criteruim 		 
Join Date: Dec 2017
Posts: 40
allex011 is on a distinguished road
Default Help switch rows to columns based on criteruim
I need help to convert the rows from the table above to the columns as in the table below (all data for one man). Is there any way to convert the rows to the columns.


Thank in andvanced
Attached Files
File Type: xlsx Days.xlsx (9.0 KB, 9 views)
Reply With Quote
  #2  
Old 02-21-2022, 07:29 AM
ArviLaanemets ArviLaanemets is offline Help switch rows to columns based on criteruim Windows 8 Help switch rows to columns based on criteruim Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
Something like this?

Columns with colored headers on Datasheet sheet are calculated! You enter/select only Number, Absence type, and Days.

PS: Remove last column on Persons sheet! I forgot deleting it before posting!
Attached Files
File Type: xlsx Days.xlsx (21.4 KB, 10 views)
Reply With Quote
  #3  
Old 02-21-2022, 11:58 AM
p45cal's Avatar
p45cal p45cal is offline Help switch rows to columns based on criteruim Windows 10 Help switch rows to columns based on criteruim Office 2019
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Very straightforward in Power Query.
See green table in attached and to update, right-click it and choose Refresh.
Attached Files
File Type: xlsx msofficeforums48538Days.xlsx (18.9 KB, 9 views)
Reply With Quote
  #4  
Old 02-24-2022, 12:05 PM
allex011 allex011 is offline Help switch rows to columns based on criteruim Windows 7 32bit Help switch rows to columns based on criteruim Office 2007
Advanced Beginner
Help switch rows to columns based on criteruim 		 
Join Date: Dec 2017
Posts: 40
allex011 is on a distinguished road
Default Help switch rows to columns based on criteruim
Thank you very much
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help switch rows to columns based on criteruim Delete blank table rows in merged document and split document in docx and pdf based on excel rows Alex1s85 Word VBA 5 05-22-2021 12:05 PM
Help switch rows to columns based on criteruim Transposing Columns and Rows in skeezix Excel 8 04-30-2020 08:23 PM
Hide rows in multiple columns based on zero values Deane Excel Programming 19 06-23-2015 11:24 PM
Help switch rows to columns based on criteruim Stack columns into rows stellag09 Excel 1 04-23-2014 03:26 AM
Help switch rows to columns based on criteruim Rows to Columns kyakobi Excel 5 12-07-2010 03:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:32 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft