Just like that, your rows become columns and your columns become rowscomplete with any. Click the down arrow under the Paste button, and then click the Transpose button on the dropdown menu. The cell you select becomes the top, left corner of whatever you’re copying. Doing simple things like if statements hasn't helped me because I need the first and last time in each group from the column. Click a blank cell where you want to copy the transposed data. Part of the problem is that the start time needs to be the timestamp one row above the 1 and the stop time needs to be the timestamp 1 row below the final 1 in a group. V and HLOOKUPS haven't done the trick for me either. I've tried setting up a pivot table and filtering, and that hasn't gotten me anywhere. The ideal output would look like this: userID startTime1 stopTime1 startTime2 stopTime2 startTime3 stopTime3 The goal is to get these transposed but to take the time values instead of the actual 1s and 0s in the columns. I have an Excel file I'm getting that looks something like this: Time 012345 2345678 5647890 7891234
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |