tag:blogger.com,1999:blog-7958828565254404797.post8564497370618301587..comments2024-03-28T07:44:59.527-07:00Comments on ListenData: Excel Formula : Convert Data from Long to Wide FormatDeepanshu Bhallahttp://www.blogger.com/profile/09802839558125192674noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-7958828565254404797.post-19837868104070429502024-02-25T11:38:07.066-08:002024-02-25T11:38:07.066-08:00There is an easier way using matrix functionThere is an easier way using matrix functionCareer guidehttps://www.blogger.com/profile/00960282060785378163noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-14705610332725043702021-12-30T00:38:05.243-08:002021-12-30T00:38:05.243-08:00Thanks! This is a good way to solve those problems...Thanks! This is a good way to solve those problems ;). I would like to understand how works every formula in the same post, however, Great article!! 10/10JonathanRagohttps://www.blogger.com/profile/12685866644577676395noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-30409613673512053902021-09-16T02:11:37.800-07:002021-09-16T02:11:37.800-07:00This is really useful. Can you please expain each ...This is really useful. Can you please expain each formula. This will be helpful in applying this formula to larger data sheets. <br />ಮನಸಿನ ಮಾತುhttps://www.blogger.com/profile/00264129192671763615noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-46874249790233767072021-08-12T00:25:37.654-07:002021-08-12T00:25:37.654-07:00You made some really good points there. I checked ...You made some really good points there. I checked on the web to find out more about the issue and found most individuals will go along with your views on this site.college homework helphttps://www.assignmentdoer.com/noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-47744346750687494132021-06-11T00:01:15.551-07:002021-06-11T00:01:15.551-07:00Use the =Transpose(range) function.Use the =Transpose(range) function.Joseph Szymczak-Parkernoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-44405136058911580982021-03-10T06:57:58.299-08:002021-03-10T06:57:58.299-08:00I have an excel sheet with four columns and more t...I have an excel sheet with four columns and more than 6000 rows. I have tried this formula and it only works for two columns and up to cell 100 across the two columns. How do I modify to suit my data?dninsiimahttps://www.blogger.com/profile/18216538657040702497noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-9853948000459836732021-03-10T05:59:43.829-08:002021-03-10T05:59:43.829-08:00What if the table had more than two columns? What if the table had more than two columns? dninsiimahttps://www.blogger.com/profile/18216538657040702497noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-19464210413548636052020-12-07T05:56:50.744-08:002020-12-07T05:56:50.744-08:00Wow, cool post. I’d like to write like this too – ...Wow, cool post. I’d like to write like this too – taking time and real hard work to make a great article…Love Shayarihttps://loveshayariii.com/noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-58819176182335328932020-06-17T16:19:12.117-07:002020-06-17T16:19:12.117-07:00Not so useful IMHO because the resulting columns h...Not so useful IMHO because the resulting columns have the various stocks listed helter-skelter, for instance, column E has Stocks D, O, D, Q, P. Usually you'd want all the D's stacked, etc.Joe Toddnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-90220775543074820472019-05-08T09:38:15.651-07:002019-05-08T09:38:15.651-07:00Thank you so much it worksThank you so much it worksDfiristhttps://www.blogger.com/profile/06356805199591162151noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-88089153847007218592018-07-28T04:55:49.366-07:002018-07-28T04:55:49.366-07:00We have another formula for extracting unique numb...We have another formula for extracting unique numbers<br /><br />Alternatively you can copy on a different sheet and drop duplicates John Lunalohttps://www.blogger.com/profile/15041848798854609226noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-77726178309492178672017-11-22T15:27:41.841-08:002017-11-22T15:27:41.841-08:00yes, it must definitely be numbers, in orderyes, it must definitely be numbers, in orderAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-41343588754439944532016-05-17T12:03:28.676-07:002016-05-17T12:03:28.676-07:00The second COUNTIF should be a MATCH() instead. I...The second COUNTIF should be a MATCH() instead. It should be:<br /><br />=IF(COLUMN(A1) <=COUNTIF($A$1:$A$100,"="&$D2),OFFSET(INDIRECT("$B"& MATCH($D2,$A$1:$A$100,0)),COLUMN(A1)-1,0),"")Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-80495229428616525992015-07-19T13:01:11.415-07:002015-07-19T13:01:11.415-07:00The data in Column A must be numbers?
I tried text...The data in Column A must be numbers?<br />I tried text data and got wrong resultsYasser Khalilhttps://www.blogger.com/profile/00968598903695196325noreply@blogger.com