아빠가 들려 주는 [데이터 시각화] 엑셀로 Long Data Wide Data 상호 전환
Synopsis
Hot to transform long_data to wide_data and the reverse USING Excel. easy and fun and a little trichky.
You Might Also Like
![아빠가 들려주는 [엑셀/데이터시각화] wide data to long data 현실적인 쉬운 방법, 통계청에서 다운받은 자료 피벗 가능하게 바꾸기](https://i.ytimg.com/vi/unYeuiRmOCw/hq720.jpg?sqp=-oaymwE2CNAFEJQDSFXyq4qpAygIARUAAIhCGAFwAcABBvABAfgB_gmAAtAFigIMCAAQARhlIGUoZTAP&rs=AOn4CLCYlDBQEOpmH1tA4-xIsmItHPRp_g)
![아빠가 들려 주는 [통계] Wide form to Long form - 엑셀로 쉽게](https://i.ytimg.com/vi/ITjywN_MoZU/hqdefault.jpg?sqp=-oaymwEcCOADEI4CSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLDLI-mn-xvyOMoQy_2Jgd3pOUb6pg)
![아빠가 들려주는 [데이터 시각화] Wide to long form](https://i.ytimg.com/vi/XcicymsRsUo/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLDwa3t6R9dPNcDLbZiLGyVjATz79Q)
![아빠가 들려 주는 [차트] Long form to wide & Chart with Excel](https://i.ytimg.com/vi/SArUjmf__8s/hqdefault.jpg?sqp=-oaymwEcCOADEI4CSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLAnJnmL4iH1CJJ05_BRZMq5xpEMcA)
![아빠가 들려 주는 [데이터시각화] Cartogram with 엑셀](https://i.ytimg.com/vi/Cpy0KhaYY-4/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLDE0cGMr-hZcqINWzxk7hY7D8obrQ)
![아빠가 들려주는 [강의/데이터 시각화] 대쉬보드? BI? 태블로? 나도 해 볼까? ‘구글 데이터 스튜디오 VS 엑셀’](https://i.ytimg.com/vi/vql2Tq88-ps/hq720.jpg?sqp=-oaymwE2CNAFEJQDSFXyq4qpAygIARUAAIhCGAFwAcABBvABAfgB1AaAAuADigIMCAAQARhlIGUoZTAP&rs=AOn4CLBBKqKBRoQ969Rdxsq3Ikmkr5s6gg)
![아빠가 들려주는 [데이터 시각화] 이건 꼭 알아야 해 R-Pivot table](https://i.ytimg.com/vi/nsR44WTFZzY/hq720.jpg?sqp=-oaymwE2CNAFEJQDSFXyq4qpAygIARUAAIhCGAFwAcABBvABAfgB1AaAAuADigIMCAAQARhlIGUoZTAP&rs=AOn4CLASLMHvanh2iYwJkgsTj1bbIepSxg)
![아빠가 들려 주는 [데이터시각화] spaghetti plot with 엑셀](https://i.ytimg.com/vi/N6OexxEFZuU/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLCBAzcka72spNMXHa5ZY7cblcAsiQ)
![아빠가 들려 주는 [데이터시각화] 밀도 곡선 densitogram with 엑셀](https://i.ytimg.com/vi/e8kFuHAa4uc/hqdefault.jpg?sqp=-oaymwEcCOADEI4CSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLAdOc8Jzyj1t7o741Zrz8WhaJQJWg)
![강의 보충 “아빠가 들려주는 [엑셀 데이터 시각화] 따라하기”들으신 분 꼭 보세요.](https://i.ytimg.com/vi/mbC2-PKp0FI/hq720_2.jpg?sqp=-oaymwE2CNAFEJQDSFXyq4qpAygIARUAAIhCGABwAcABBvABAfgBngSAAoQHigIMCAAQARhmIGYoZjAP&rs=AOn4CLBSf5sgh2ex5MIcfZEi0vvKYokcgA)
![아빠가 들려주는 [엑셀 데이터 시각화] 35. Forest plot 추가](https://i.ytimg.com/vi/DboIUtElrr4/hqdefault.jpg?sqp=-oaymwEcCOADEI4CSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLBAAAszUev-K-i8v2t4zTMwPhK2FQ)
Download Options
Choose a download method below. All links open in new tabs.
| Service | Features | Action |
|---|---|---|
| Ssvid |
MP4 & MP3 • HD Quality • Browser Extension Available
|
Download |
| SaveFrom |
MP4 & MP3 • HD Quality • Browser Extension Available
|
Download |
Security Notice: These are third-party services. We recommend using antivirus software and being cautious of pop-up ads.